package queenb.web.crm.store;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import oracle.jdbc.OracleTypes;

import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.net.entitybean.K100;

import queenb.web.crm.inteface.K100Inf;
import queenb.web.store.EmployeeStore;
import queenb.web.util.PackageContants;

/*
 * To change this template, choose Tools | Templates and open the template in
 * the editor.
 */
/**
 *
 * @author Nguyen Hung
 */
public class K100Store extends K100 implements K100Inf {

    @Override
    public int updateK100By(int pnPK100, int pnFH000, int pnFH200Q,
            int pnFH200, int pnFK200, String pvFK250, int pnFK300, int pnFK330,
            int pnFK350, int pnFK400, String pvKV101, String pvKV102, String pvKV103,
            String pvKV104, String pvKV105, String pvKV106, String pvKV107,
            String pvKV108, String pvKV109, String pvKV110, String pvKV111,
            String pvKV112, int pnKN114,Date KD115, int pnFH150, int pnFV350, int pnFN550, String pvLOGIN) {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.UPDATE_K100, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.INTEGER, pnPK100),
                        new Param(OracleTypes.INTEGER, pnFH000),
                        new Param(OracleTypes.INTEGER, pnFH200Q),
                        new Param(OracleTypes.INTEGER, pnFH200),
                        new Param(OracleTypes.INTEGER, pnFK200),
                        new Param(OracleTypes.CHAR, pvFK250),
                        new Param(OracleTypes.INTEGER, pnFK300),
                        new Param(OracleTypes.INTEGER, pnFK330),
                        new Param(OracleTypes.INTEGER, pnFK350),
                        new Param(OracleTypes.INTEGER, pnFK400),
                        new Param(OracleTypes.CHAR, pvKV101),
                        new Param(OracleTypes.CHAR, pvKV102),
                        new Param(OracleTypes.CHAR, pvKV103),
                        new Param(OracleTypes.CHAR, pvKV104),
                        new Param(OracleTypes.CHAR, pvKV105),
                        new Param(OracleTypes.CHAR, pvKV106),
                        new Param(OracleTypes.CHAR, pvKV107),
                        new Param(OracleTypes.CHAR, pvKV108),
                        new Param(OracleTypes.CHAR, pvKV109),
                        new Param(OracleTypes.CHAR, pvKV110),
                        new Param(OracleTypes.CHAR, pvKV111),
                        new Param(OracleTypes.CHAR, pvKV112),
                        new Param(OracleTypes.INTEGER, pnKN114),
                        new Param(OracleTypes.DATE, KD115),
                        new Param(OracleTypes.INTEGER, pnFH150),
                        new Param(OracleTypes.INTEGER, pnFV350),
                        new Param(OracleTypes.INTEGER, pnFN550),
                        new Param(OracleTypes.CHAR, pvLOGIN)});
            Param[] p = dateStatement.getMapParam();
            return super.update(dateStatement, K100.class);
        } catch (SQLException ex) {
            System.out.println("---->" + ex.getMessage());
            return 0;
        }

    }

    @Override
    public int deleteK100(int pnPK100, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.DELETE_K100, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnPK100),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.update(dataStatement, K100.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(EmployeeStore.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
            return 0;
        }
    }

    @Override
    public List<K100> getListTabK100(int pnFH200, int pnFH000, int pnFK100, int pnfk350,
            String pvKV101, int pnKN114, int pnOFFSET,
            int pnLIMIT, int pnSORT,
            int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFK100),
                    new Param(OracleTypes.INTEGER, pnfk350),
                    new Param(OracleTypes.CHAR, pvKV101),
                    new Param(OracleTypes.INTEGER, pnKN114),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.find(dataStatement, K100.class);
        } catch (Exception ex) {
            System.out.println("erorr get list" + ex.getMessage());
            return new ArrayList<K100>();
        }
    }

    @Override
    public List<K100> getListTabK100WithID(String pvLOGIN, int pnPK100) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_ID, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.CHAR, pvLOGIN),
                    new Param(OracleTypes.INTEGER, pnPK100),});
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCombK100(int pnFH000, int pnFH200, int pnFK350, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_COMBK100, OracleTypes.CURSOR, new Param[]{
                        new Param(OracleTypes.INTEGER, pnFH000),
                        new Param(OracleTypes.INTEGER, pnFH200),
                        new Param(OracleTypes.INTEGER, pnFK350),
                        new Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCombK100DV(int pnFH000, int pnFH200, int pnFN750, int pnFA000, int pnFV200, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_COMBK100_DV, OracleTypes.CURSOR, new Param[]{
                        new Param(OracleTypes.INTEGER, pnFH000),
                        new Param(OracleTypes.INTEGER, pnFH200),
                        new Param(OracleTypes.INTEGER, pnFN750),
                        new Param(OracleTypes.INTEGER, pnFA000),
                        new Param(OracleTypes.INTEGER, pnFV200),
                        new Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public int updateColumnLogo(int pnPK100, byte[] pnVALUE, String pvLOGIN) {
        try {
            DataStatement updateK100 = new DataStatement(PackageContants.ORG_UPDATE_K100, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.INTEGER, pnPK100),
                        new Param(OracleTypes.BLOB, pnVALUE),
                        new Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.update(updateK100, null);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    @Override
    public List<K100> getListCompany_NA(int pnFH000, int pnFH200, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_NAM_KHCT, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCompany_Cus(int pnFH200, int pnFH000, String pvSEARC, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_NAM_KHCT1, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCompany_MO(int pnFH000, int pnFH200, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_MOB_KHCT, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCompany_ALL(int pnFH000, int pnFH200, int PK100, int pnFK350, int pnFK400, int pnKN114, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_ALL_KHCT, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, PK100),
                    new Param(OracleTypes.INTEGER, pnFK350),
                    new Param(OracleTypes.INTEGER, pnFK400),
                    new Param(OracleTypes.INTEGER, pnKN114),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCompany_MST(int pnFH000, int pnFH200, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_MST, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> LISTOFTABK100EX(int pnFH000, int pnFH200, int pnFK400, String pvKV451, String pvSEARC, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100EX, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFK400),
                    new Param(OracleTypes.CHAR, pvKV451),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.find(dataStatement, K100.class);
        } catch (Exception ex) {
            System.out.println("erorr get list" + ex.getMessage());
            return new ArrayList<K100>();
        }
    }

    @Override
    public List<K100> LISTOFTABK100NO(int pnFH000, int pnFH200, int pnFK400, String pvKV451, String pvSEARC, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100NO, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFK400),
                    new Param(OracleTypes.CHAR, pvKV451),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.find(dataStatement, K100.class);
        } catch (Exception ex) {
            System.out.println("erorr get list" + ex.getMessage());
            return new ArrayList<K100>();
        }
    }

    @Override
    public List<K100> getListCompany_ALL1(int pnFH000, int pnFH200, int pnFK100, int pnFK350, int pnKn114, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {

        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_ALL_KHCT1, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFK100),
                    new Param(OracleTypes.INTEGER, pnFK350),
                    new Param(OracleTypes.INTEGER, pnKn114),
                    new Param(OracleTypes.CHAR, pvSEARC),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<K100> getListK100KB113(int FK100, String pvLogin) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_KB113, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, FK100),
                    new Param(OracleTypes.CHAR, pvLogin)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(K100Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getListCompany_LDAYS(int pnFH000, int pnFH200, int pnFK350, int pnLDAYS, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_ALL_HIS, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFK350),
                    new Param(OracleTypes.INTEGER, pnLDAYS),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> LISTOFTABK100STA(int pnFH000, int pnFH200, int pnPK100, int pnFK350,int pnKN114, int pnFK330, Date pdMONFR, Date pdMONTO, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_K100_STA, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnPK100),
                    new Param(OracleTypes.INTEGER, pnFK350),
                      new Param(OracleTypes.INTEGER, pnKN114),
                    new Param(OracleTypes.INTEGER, pnFK330),
                    new Param(OracleTypes.DATE, pdMONFR),
                    new Param(OracleTypes.DATE, pdMONTO),
             
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> LISTOFTABK100CCA(int pnFH000, int pnFH200, int pnPK100, int pnFK350, int pnKN114, int pnFN550, int pnFN750, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
         DataStatement dataStatement = new DataStatement(PackageContants.KCURPKS_ListOfTabK100CCA, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnPK100),
                    new Param(OracleTypes.INTEGER, pnFK350),
                      new Param(OracleTypes.INTEGER, pnKN114),
                    new Param(OracleTypes.INTEGER, pnFN550),
                    new Param(OracleTypes.INTEGER, pnFN750),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<K100> getReport_listoftabK100(int pnFH000, int pnFH200, int pnFK350, int pnLDAYS, Date pdFRDAT, Date pdTODAT, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        DataStatement dataStatement = new DataStatement(PackageContants.report_listoftabk100, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFK350),
                    new Param(OracleTypes.INTEGER, pnLDAYS),
                      new Param(OracleTypes.DATE, pdFRDAT),
                    new Param(OracleTypes.DATE, pdTODAT),
                    new Param(OracleTypes.INTEGER, pnOFFSET),
                    new Param(OracleTypes.INTEGER, pnLIMIT),
                    new Param(OracleTypes.INTEGER, pnSORT),
                    new Param(OracleTypes.INTEGER, pnDIRECTION),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        try {
            return super.find(dataStatement, K100.class);
        } catch (SQLException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            Logger.getLogger(CustomerStore.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
}
